DEPT

The DEPT dimension contains records for each department within an organization. For example, radiology, emergency, finance, and so on.

The following table lists all of the options available in this dimension table:

Column Description
DEPT The Axiom department number, which is formed by combining the entity and cost center.
Description

The department description. The naming convention is entity abbreviation with department description. For example, MHS Operating Room.

NOTE: For closed departments, add three asterisks to the beginning of the description. For example, MHS *** Operating Room. Descriptions should not be in all capital letters.

Entity The Axiom entity code. The description lookup table is in the ENTITY dimension table. This should be the Business Unit, and match the first three to four characters of the department number.
CostCenter The cost center portion of the department number. You can use this for comparative reporting across entities, such as comparing the cost per unit of all operating rooms across your health system.
RptMap Used to consolidate departments for reporting.
BudgetGroup

A collection of departments used primarily for plan file purposes. This is commonly setup by a KHA consultant during implementation but can easily be updated by clients. For example, departments 16010 and 16020 may be assigned to EMC budget group.

NOTE: BudgetGroup is a validated dimension so additions and deletions need to first be added/deleted in the associated validation table.

ProdMap Used to consolidate departments for productivity reporting.
VP The Vice President responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.
Director The director responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.
Manager The manager responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.
Division The division for rollup reporting, which is defined by your organization. You can use this information to consolidate types of departments together for reporting. For example, you can use the word Radiology to combine all radiology departments across all entities.
KHABgtCode Used to identify departments to combine during plan-file creation.
DeptType Determines the Direct or Indirect department category. Direct departments are those that generally provide patient care services and generate revenue, while Indirect departments are involved in support services and do not generate patient care related revenue.
Owner

Used to identify the network ID of the person responsible for initial input of the plan file (i.e. Manager). It should be the same as their Axiom login ID. Naming convention would be first initial, full last name (or whatever your network ID naming convention is).

If your organization does not use this role for plan file approval, type [skip] in the cell.

IMPORTANT: Do not leave this cell blank.
KHABgtTemplate

Used to identify the template to use for plan file creation. Valid options include the following:

  • Master
  • NA
  • NoBudget
  • RollingForecast

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

Reviewer

The network ID of the person responsible for reviewing the cost management plan, for example, Director. This information should be the same as the user's Axiom login ID. The naming convention is first initial, full last name or whatever your network ID naming convention is.

If your organization does not use this role for plan file approval, type [skip] in the cell.

IMPORTANT: Do not leave this cell blank.
Approver

The network ID of the person responsible for approving the cost management plan, for example, VP. This information should be the same as their Axiom login ID. The naming convention is first initial, full last name or whatever your network ID naming convention is.

If your organization does not use this role for plan file approval, type [skip] in the cell.

IMPORTANT: Do not leave this cell blank.
CostMap Allows departments to processed as a group in the unit cost processing phase of cost accounting. All costs for the group are combined and allocated to all of the Cost Items within the group. In most cases, the first or largest department of the groups becomes the target CostMap definition to which the other members are mapped.
MarkupName

The specified markup table to use when processing unit costs using the Reverse Markup method.

NOTE: Currently only one table is available per department.
LaborType

Used to identify the labor method to use for plan file creation. Valid options are:

  • altEmployee
  • Employee
  • HHLabor
  • JobCode
  • JobCodeADC
  • NA
  • NoBudget
  • Staffing

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

TplOptions

Used to identify the template option based on licensed products. Valid options include the following:

  • Master (common for all clients)
  • MasterCDM (used for clients licensed for CDM option)
  • MasterProvider
  • NoBudget
  • RFProvider
CM_Template Used to assign a specific Axiom Cost Management plan template.
CM_Map Similar to RptMap, used to consolidate departments for reporting.
FinContact Used to assign the finance contact for a department during the cost management process.
KHACMDimGrp Used to identify the Standard Line selected from the ACCT dimension for use in budget planning specifically for the budget values. Valid options are the options used on the ACCT dimension. For example the common ones uses include: KHAStdLine, PHYStdLine.
KeyStatDesc Used to identify the description of the primary statistic for each department.
CM_TeamMap Used to create team-planning workbooks. You can create teams by combining like departments or like accounts for team Axiom Cost Management planning.
JobcodeDimGrp Used to designate which labor type distribution set applies to the associated department. KHAInt is the standard set of job code labor types. PhyInt is the modified set of job code labor types.
Campus Used as part of Axiom Cost Accounting.
ProviderType Select, by dept, whether to use the Detail or Summary options for provider plan files.
ProjDimGrp Used to identify the Standard Line selected from the ACCT dimension for use in budget planning specifically for the projection values. Valid options are the options used on the ACCT dimension. For example the common ones uses include CYPMethod.
ShowOnList_Budgeting

Used to identify if a department displays to be selected during the plan file creation process. Valid entries include the following:

  • TRUE
  • FALSE
CM_Team Create teams by combining like departments for team Axiom Cost Management planning.
KHABgtMap Used for combining departments during plan-file creation. This column is also used when more than one department is needed in one plan file.
CM_Division Used to group similar departments for Axiom Cost Management reporting and analytics.
CYFDimGrp

Used to identify which CYFMethod column each department uses to forecast accounts. Valid options are:

  • CYFMethod - Uses the method specified in ACCT.CYFMethod
  • NA - Not Applicable
  • [Other Column Name] - Uses the method specified in the corresponding column on the ACCT dimension table
KHAStandardClass Used for reporting.
FPNode Used to group the department to the appropriate FPNode in Axiom Financial Planning.
CM_BMarkStatus

Used to define which departments to include in Axiom Cost Management benchmarking reports and analytics. Valid entries include the following:

  • Yes – Type to include the department.
  • No – Type to exclude the department.
FPType Used to group the department to the appropriate FPTYPE in Axiom Financial Planning.
FPNodeBS Balance Sheet node for Axiom Financial Planning.
CM_DeptStandard Used for mapping departments to external benchmark data. This mapping matches the department to the ExternalBMark information in the Axiom Cost Management file groups.
CM_PdHrsMetricID The paid hours metric ID from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
CM_WkdHrsMetricID The metric ID for worked hours from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
CM_NonLabor1MetricID The metric ID for NonLabor 1 from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
CM_NonLabor2MetricID The metric ID for NonLabor 2 from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
BudLocalAdmin1 Used to select the local administrator for Axiom Budgeting.
CM_CombineStat

Used to determine if key statistics should be combined when grouping departments together with CM_Map grouping column for Axiom Cost Management. Valid entries include the following:

  • Y – Type if the key statistics of the rolled up departments are to be cumulative.
  • N – Type to use only the key statistics from the surviving department.
CM_NonLabor3MetricID The metric ID for NonLabor 3 from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
CM_NonLabor4MetricID The metric ID for NonLabor 4 from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
CM_NonLabor5MetricID The metric ID for NonLabor 5 from external benchmark. Elements are validated to the MetricID table. Used to link a department with specific metrics in the CM_Benchmarks_yyyy tables. Used only in Axiom Cost Management.
BudLocalAdmin2 Used to select the local administrator for Axiom Budgeting.
BudLocalAdmin3 Used to select the local administrator for Axiom Budgeting.
FlexGroup Used for grouping departments together for the flexible budget utility. (For example, Imaging).
FlexDept

Used for defining each department as fixed or variable during the flexible budget utility. Valid entries include the following:

  • Yes
  • No
  • NA
CM_ShowOnList

Used to define which departments to build Axiom Cost Management plan files. Valid entries include the following:

  • TRUE – Type this to build a plan file.
  • FALSE – Type this to exclude from plan file lists and build.
CM_PlanGroup Used to group departments together for applying assumptions and configurations in Axiom Cost Management driver files.
CM_ExtBenchmarkSource The source name of the external benchmark to use for this department in Axiom Cost Management. Used to link a department with the CM_Benchmarks_yyyy tables.
ShowOnList_Capital

Used to define which departments to build Axiom Capital Planning plan files. Valid entries include the following:

  • TRUE
  • FALSE
PM_IT The IT reviewer assigned for Process Management in Axiom Capital Planning and Capital Tracking.
RFGroup

Used to define your forecast groups. Consider:

  • Management structure and cultural impact
  • Team concept versus individual department managers
  • The availability of a statistic that can be collected
PM_Facilities The Facilities reviewer assigned for Process Management in Axiom Capital Planning and Capital Tracking.
PM_Clinical The Clinical Engineering reviewer assigned for Process Management in the Axiom Capital Planning and Capital Tracking systems.
PM_Voting The owner of the prioritization process assigned for Process Management in Axiom Capital Planning and Capital Tracking.